This Analysis Model is used for: Maintenance. There is a list of Analysis Models pre-packaged and delivered as a part of Analysis Models - Power BI, and you can refer to them here.
Main analysis scenarios are:
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| FACT TIME | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| WORK TASK POSTINGS | FACT_JT_TASK_ACCT_PQ_BI | FACT_JT_TASK_ACCT_PQ | On Line |
| WO BUDGET | FACT_WO_BUDGET_PQ_BI | FACT_WO_BUDGET_PQ | On Line |
| WORK TASK ACTUALS SALES | FACT_WO_TASK_ACT_SALES_PQ_BI | FACT_WO_TASK_ACT_SALES_PQ | On Line |
| FACT WORK ORDER | FACT_WORK_ORDER_PQ_BI | FACT_WORK_ORDER_PQ | On Line |
| WORK TASK ACTUALS COST | FACT_WORK_TASK_ACT_COST_PQ_BI | FACT_WORK_TASK_ACT_COST_PQ | On Line |
| WORK TASK PLANNED | FACT_WORK_TASK_PLANNED_PQ_BI | FACT_WORK_TASK_PLANNED_PQ | On Line |
| FACT WORK TASK | FACT_WORK_TASK_PQ_BI | FACT_WORK_TASK_PQ | On Line |
| ASSET HEALTH MEASURES | FACT_ASSET_HEALTH_BI | FACT_ASSET_HEALTH | On Line |
| CURRENCY RATES | FACT_CURRENCY_RATES_PQ_BI | FACT_CURRENCY_RATES_PQ | On Line |
Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources
FACT_WO_TASK_ACTUALS_SALES
Work Order Actuals Sales Information Source is based on revenues related to Work Tasks. This Information Source carries transactions for time reporting, material issues, tools usages, expenses like revenue amounts.
FACT_WORK_TASK_ACTUALS_COST
Work Task Actuals Cost Information Source is based on costs related to Work Tasks. This information source carries transactions for Expenses, External, Fixed Price, Material, Personnel and Tool/Equipment.
FACT_WO_BUDGET
Work Order Budget Information Source is based on the manually entered budget costs and revenues on workorders. It should mainly be used in conjunction with Work Order Actuals information source for analysis.
FACT_WORK_TASK_PLANNED
Work Task Planned Information Source is based on the planning lines on the work tasks. It should mainly be used in conjunction with Work Task Actuals information source for analysis.
FACT_WORK_ORDERS
Work Order Information Source is based on IFS\Work Orders. This information source carries work orders in all statuses, i.e both active and historical work orders as well as work requests and fault reports.
FACT_WORK_TASK
A work order can have one or more work tasks connected to it. Work task is an entity which executes the work initiated, for example through a Fault Report or Service request. If IFS/Service Management is used, performed maintenance activities are reported, monitored and invoiced to customer through work tasks.
FACT_JT_TASK_ACCOUNTING
Work Task Accounting Information Source is based on actual transactions related to Work Tasks. It combines data from Work Order, Work Task, Work Task Transaction and Work Task Cost
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| ACCOUNT | DIM_ACCOUNT_BI | DIM_ACCOUNT | On Line |
| ACTIVITY | DIM_ACTIVITY_BI | DIM_ACTIVITY | On Line |
| CAUSE | DIM_CAUSE_BI | DIM_CAUSE | On Line |
| CLASS | DIM_CLASS_BI | DIM_CLASS | On Line |
| CANCEL TASK CAUSE | DIM_CANCEL_TASK_CAUSE_BI | DIM_CANCEL_TASK_CAUSE | On Line |
| CODE B | DIM_CODE_B_BI | DIM_CODE_B | On Line |
| CODE C | DIM_CODE_C_BI | DIM_CODE_C | On Line |
| CODE D | DIM_CODE_D_BI | DIM_CODE_D | On Line |
| CODE E | DIM_CODE_E_BI | DIM_CODE_E | On Line |
| CODE F | DIM_CODE_F_BI | DIM_CODE_F | On Line |
| CODE G | DIM_CODE_G_BI | DIM_CODE_G | On Line |
| CODE H | DIM_CODE_H_BI | DIM_CODE_H | On Line |
| CODE I | DIM_CODE_I_BI | DIM_CODE_I | On Line |
| CODE J | DIM_CODE_J_BI | DIM_CODE_J | On Line |
| COMPANY | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| COMPATIBLE UNIT | DIM_CMPUNT_COMPATIBLE_UNIT_BI | DIM_CMPUNT_COMPATIBLE_UNIT | On Line |
| CUSTOMER | DIM_CUSTOMER_BI | DIM_CUSTOMER | On Line |
| DISCOVERY | DIM_DISCOVERY_BI | DIM_DISCOVERY | On Line |
| EVENT | DIM_EVENT_BI | DIM_EVENT | On Line |
| FAILING COMPONENT | DIM_FAILING_COMPONENT_BI | DIM_FAILING_COMPONENT | On Line |
| FAULT TYPE | DIM_FAULT_TYPE_BI | DIM_FAULT_TYPE | On Line |
| ITEM CLASS FUNCTION | DIM_ITEM_CLASS_FUNCTION_BI | DIM_ITEM_CLASS_FUNCTION | On Line |
| ITEM CLASS SOURCE | DIM_IC_SOURCE_TYPE_BI | DIM_IC_SOURCE_TYPE | On Line |
| LINEAR ASSET | DIM_LINAST_LINEAR_ASSET_PQ_BI | DIM_LINAST_LINEAR_ASSET_PQ | On Line |
| OPERATIONAL STATUS | DIM_OPERATIONAL_STATUS_BI | DIM_OPERATIONAL_STATUS | On Line |
| ORGANIZATION | DIM_ORGANIZATION_BI | DIM_ORGANIZATION | On Line |
| PERFORMED ACTION | DIM_PERFORMED_ACTION_BI | DIM_PERFORMED_ACTION | On Line |
| PM GROUP | DIM_PM_GROUP_BI | DIM_PM_GROUP | On Line |
| PRIORITY | DIM_PRIORITY_BI | DIM_PRIORITY | On Line |
| PROJECT | DIM_PROJECT_BI | DIM_PROJECT | On Line |
| PROJECT PROGRAM | DIM_PROJECT_PROGRAM_BI | DIM_PROJECT_PROGRAM | On Line |
| REPORTING CURRENCY | FACT_CURRENCY_RATES_BI,LUP_REP_CURR_RATE_TYPE_TC,DIM_CURRENCY_CODE_BI,DIM_CURRENCY_RATE_TYPE_BI | DIM_REPORTING_CURRENCY | On Line |
| REPORTING PERIOD | DIM_REPORTING_PERIOD_PQ_BI | DIM_REPORTING_PERIOD_PQ | On Line |
| SALES PART | DIM_SALES_PART_BI | DIM_SALES_PART | On Line |
| SERVICE CONTRACT | DIM_SERVICE_CONTRACT_LINE_BI | DIM_SERVICE_CONTRACT_LINE | On Line |
| SITE | DIM_SITE_BI | DIM_SITE | On Line |
| SLA ORDER | DIM_SLA_ORDER_BI | DIM_SLA_ORDER | On Line |
| SLA ORDER LINE | DIM_SLA_ORDER_LINE_BI | DIM_SLA_ORDER_LINE | On Line |
| SOURCE CONNECTION | DIM_JT_CONNECTED_OBJECT_BI | DIM_JT_CONNECTED_OBJECT | On Line |
| SOURCE OBJECT | DIM_SOURCE_OBJECT_BI | DIM_SOURCE_OBJECT | On Line |
| SUPPLIER | DIM_SUPPLIER_BI | DIM_SUPPLIER | On Line |
| SYMPTOM | DIM_SYMPTOM_BI | DIM_SYMPTOM | On Line |
| TASK ACCOUNTING TYPE | DIM_TASK_ACCOUNTING_TYPE_BI | DIM_TASK_ACCOUNTING_TYPE | On Line |
| TIME TYPE | DIM_TIME_TYPE_BI | DIM_TIME_TYPE | On Line |
| TRANSACTION TYPE | DIM_TRANSACTION_TYPE_BI | DIM_TRANSACTION_TYPE | On Line |
| VIM SERIAL | DIM_VIM_SERIAL_BI | DIM_VIM_SERIAL | On Line |
| WO CONNECTION TYPE | DIM_WO_CONNECTION_TYPE_BI | DIM_WO_CONNECTION_TYPE | On Line |
| WORK ORDER | DIM_WORK_ORDER_BI | DIM_WORK_ORDER | On Line |
| WORK STAGE | DIM_WORK_STAGE_BI | DIM_WORK_STAGE | On Line |
| WORK TASK | DIM_WORK_TASK_BI | DIM_WORK_TASK | On Line |
| WORK TYPE | DIM_WORK_TYPE_BI | DIM_WORK_TYPE | On Line |
| WORK TYPE CATEGORY | DIM_WORK_TYPE_CATEGORY_BI | DIM_WORK_TYPE_CATEGORY | On Line |
| CRITICALITY | DIM_CRITICALITY_BI | DIM_CRITICALITY | On Line |
| WO COST TYPE | DIM_WO_COST_TYPE_BI | DIM_WO_COST_TYPE | On Line |
| ITEM CLASS | DIM_ITEM_CLASS_PQ_BI | DIM_ITEM_CLASS_PQ | On Line |
| REPORTING DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| SUB PROJECT | DIM_SUB_PROJECT_PQ_BI | DIM_SUB_PROJECT_PQ | On Line |
| WT CONNECTION TYPE REPORTED | DIM_WO_CONNECTION_TYPE_BI | DIM_WO_CONNECTION_TYPE | On Line |
| WT CONNECTION TYPE ACTUAL | DIM_WO_CONNECTION_TYPE_BI | DIM_WO_CONNECTION_TYPE | On Line |
| VOUCHER DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| SOURCE SITE | DIM_SITE_BI | DIM_SITE | On Line |
| SLA LATEST START DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| SLA LATEST FINISH DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| REQUIRED START DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| REQUIRED FINISH DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| REPORTED OBJECT SITE | DIM_SITE_BI | DIM_SITE | On Line |
| PLANNED START DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| PLANNED FINISH DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| PLANNED DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| ORGANIZATION SITE | DIM_SITE_BI | DIM_SITE | On Line |
| CREATED DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| ACTUAL START DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| ACTUAL OBJECT SITE | DIM_SITE_BI | DIM_SITE | On Line |
| ACTUAL FINISH DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| ACTUAL EQUIPMENT OBJECT | DIM_EQUIPMENT_OBJECT_PQ_BI | DIM_EQUIPMENT_OBJECT_PQ | On Line |
| REPORTED EQUIPMENT OBJECT | DIM_EQUIPMENT_OBJECT_BI | DIM_EQUIPMENT_OBJECT | On Line |
| ASSET TYPE | DIM_ASSET_TYPE_BI | DIM_ASSET_TYPE | On Line |
| ASSET HEALTH HISTORY | FACT_ASSET_HEALTH_HISTORY_BI | FACT_ASSET_HEALTH_HISTORY | On Line |
| ASSET HEALTH INDI HST | FACT_ASSET_HEALTH_INDI_HST_BI | FACT_ASSET_HEALTH_INDI_HST | On Line |
| ASSET HEALTH INDICATOR | FACT_ASSET_HEALTH_INDICATOR_BI | FACT_ASSET_HEALTH_INDICATOR | On Line |
| ASSET HEALTH LEVEL | FACT_ASSET_HEALTH_LEVEL_BI | FACT_ASSET_HEALTH_LEVEL | On Line |
| ASSET HEALTH | FACT_ASSET_HEALTH_BI | FACT_ASSET_HEALTH | On Line |
| ASSET HEALTH DIMENSION | DIM_ASSET_HEALTH_BI | DIM_ASSET_HEALTH | On Line |
| ASSET HEALTH INDICATOR DIMENSION | DIM_ASSET_HEALTH_INDICATOR_BI | DIM_ASSET_HEALTH_INDICATOR | On Line |
| COLOR LEVEL | N/A | EAM_COLOR_LEVEL | On Line |
| EnvPath | N/A | EAM_ENVIRONMENT_PATH | On Line |
| HEALTH LEVEL | N/A | EAM_HEALTH_LEVEL | On Line |
| Locations | N/A | N/A |
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| CURRENCY RATES (DIM_REPORTING_CURRENCY_ID) - REPORTING CURRENCY (ID) |
| CURRENCY RATES (DIM_TIME_ID) - REPORTING DATE (ID) |
| FACT TIME (ID) - ACTUAL FINISH DATE (ID) |
| FACT TIME (ID) - ACTUAL START DATE (ID) |
| FACT TIME (ID) - CREATED DATE (ID) |
| FACT TIME (ID) - PLANNED DATE (ID) |
| FACT TIME (ID) - PLANNED FINISH DATE (ID) |
| FACT TIME (ID) - PLANNED START DATE (ID) |
| FACT TIME (ID) - REPORTING DATE (ID) |
| FACT TIME (ID) - REQUIRED FINISH DATE (ID) |
| FACT TIME (ID) - REQUIRED START DATE (ID) |
| FACT TIME (ID) - SLA LATEST FINISH DATE (ID) |
| FACT TIME (ID) - SLA LATEST START DATE (ID) |
| FACT TIME (ID) - VOUCHER DATE (ID) |
| FACT WORK ORDER (Dim_Activity_ID) - ACTIVITY (ID) |
| FACT WORK ORDER (DIM_COMPANY_ID) - COMPANY (ID) |
| FACT WORK ORDER (Dim_Compatible_Unit_ID) - COMPATIBLE UNIT (ID) |
| FACT WORK ORDER (Dim_Customer_ID) - CUSTOMER (ID) |
| FACT WORK ORDER (Dim_Date_Actual_Complete_ID) - ACTUAL FINISH DATE (ID) |
| FACT WORK ORDER (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID) |
| FACT WORK ORDER (Dim_Date_Created_ID) - CREATED DATE (ID) |
| FACT WORK ORDER (Dim_Date_Planned_Complete_ID) - PLANNED FINISH DATE (ID) |
| FACT WORK ORDER (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| FACT WORK ORDER (Dim_Date_Required_Complete_ID) - REQUIRED FINISH DATE (ID) |
| FACT WORK ORDER (Dim_Date_Required_Start_ID) - REQUIRED START DATE (ID) |
| FACT WORK ORDER (Dim_Discovery_ID) - DISCOVERY (ID) |
| FACT WORK ORDER (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| FACT WORK ORDER (Dim_Equipment_Object_ID) - REPORTED EQUIPMENT OBJECT (ID) |
| FACT WORK ORDER (Dim_Event_ID) - EVENT (ID) |
| FACT WORK ORDER (Dim_Linear_Asset_ID) - LINEAR ASSET (ID) |
| FACT WORK ORDER (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| FACT WORK ORDER (DIM_ORGANIZATION_ID) - ORGANIZATION (ID) |
| FACT WORK ORDER (Dim_Priority_ID) - PRIORITY (ID) |
| FACT WORK ORDER (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| FACT WORK ORDER (Dim_Project_ID) - PROJECT (ID) |
| FACT WORK ORDER (Dim_Reporting_Date_ID) - REPORTING DATE (ID) |
| FACT WORK ORDER (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID) |
| FACT WORK ORDER (DIM_SITE_ID) - SITE (ID) |
| FACT WORK ORDER (Dim_Sla_Order_No) - SLA ORDER (ID) |
| FACT WORK ORDER (Dim_Sub_Project_ID) - SUB PROJECT (ID) |
| FACT WORK ORDER (Dim_Supplier_ID) - SUPPLIER (ID) |
| FACT WORK ORDER (Dim_Symptom_ID) - SYMPTOM (ID) |
| FACT WORK ORDER (Dim_Vim_Serial_ID) - VIM SERIAL (ID) |
| FACT WORK ORDER (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID) |
| FACT WORK ORDER (DIM_WORK_ORDER_ID) - WORK ORDER (ID) |
| FACT WORK ORDER (DIM_WORK_TYPE_CATEGORY_ID) - WORK TYPE CATEGORY (ID) |
| FACT WORK ORDER (DIM_WORK_TYPE_ID) - WORK TYPE (ID) |
| FACT WORK TASK (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| FACT WORK TASK (Dim_Activity_ID) - ACTIVITY (ID) |
| FACT WORK TASK (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID) |
| FACT WORK TASK (Dim_Cause_ID) - CAUSE (ID) |
| FACT WORK TASK (Dim_Class_ID) - CLASS (ID) |
| FACT WORK TASK (Dim_Company_ID) - COMPANY (ID) |
| FACT WORK TASK (Dim_Customer_ID) - CUSTOMER (ID) |
| FACT WORK TASK (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID) |
| FACT WORK TASK (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| FACT WORK TASK (Dim_Date_Reported_ID) - REPORTING DATE (ID) |
| FACT WORK TASK (Dim_Discovery_ID) - DISCOVERY (ID) |
| FACT WORK TASK (Dim_Event_ID) - EVENT (ID) |
| FACT WORK TASK (Dim_Failing_Component_ID) - FAILING COMPONENT (ID) |
| FACT WORK TASK (Dim_Fault_Type_ID) - FAULT TYPE (ID) |
| FACT WORK TASK (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID) |
| FACT WORK TASK (Dim_Item_Class_ID) - ITEM CLASS (ID) |
| FACT WORK TASK (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID) |
| FACT WORK TASK (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| FACT WORK TASK (Dim_Organization_ID) - ORGANIZATION (ID) |
| FACT WORK TASK (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID) |
| FACT WORK TASK (Dim_PM_Group_ID) - PM GROUP (ID) |
| FACT WORK TASK (Dim_Priority_ID) - PRIORITY (ID) |
| FACT WORK TASK (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| FACT WORK TASK (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID) |
| FACT WORK TASK (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID) |
| FACT WORK TASK (Dim_Site_ID) - SITE (ID) |
| FACT WORK TASK (Dim_Site_ID) - SOURCE SITE (ID) |
| FACT WORK TASK (Dim_SLA_ORDER_Line_ID) - SLA ORDER LINE (ID) |
| FACT WORK TASK (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID) |
| FACT WORK TASK (Dim_Supplier_ID) - SUPPLIER (ID) |
| FACT WORK TASK (Dim_Symptom_ID) - SYMPTOM (ID) |
| FACT WORK TASK (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID) |
| FACT WORK TASK (Dim_Work_Order_ID) - WORK ORDER (ID) |
| FACT WORK TASK (Dim_Work_Stage_ID) - WORK STAGE (ID) |
| FACT WORK TASK (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID) |
| FACT WORK TASK (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WO BUDGET (Dim_Activity_ID) - ACTIVITY (ID) |
| WO BUDGET (Dim_Company_ID) - COMPANY (ID) |
| WO BUDGET (Dim_Compatible_Unit_ID) - COMPATIBLE UNIT (ID) |
| WO BUDGET (Dim_Cost_Type_ID) - WO COST TYPE (ID) |
| WO BUDGET (Dim_Customer_ID) - CUSTOMER (ID) |
| WO BUDGET (Dim_Date_Earliest_Start_ID) - REQUIRED START DATE (ID) |
| WO BUDGET (Dim_Date_Required_Compl_ID) - REQUIRED FINISH DATE (ID) |
| WO BUDGET (Dim_Discovery_ID) - DISCOVERY (ID) |
| WO BUDGET (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| WO BUDGET (Dim_Linear_Asset_ID) - LINEAR ASSET (ID) |
| WO BUDGET (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| WO BUDGET (Dim_Organization_ID) - ORGANIZATION (ID) |
| WO BUDGET (Dim_Priority_ID) - PRIORITY (ID) |
| WO BUDGET (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| WO BUDGET (Dim_Project_ID) - PROJECT (ID) |
| WO BUDGET (Dim_Reporting_Date_ID) - REPORTING DATE (ID) |
| WO BUDGET (Dim_Site_ID) - SITE (ID) |
| WO BUDGET (Dim_Sub_Project_ID) - SUB PROJECT (ID) |
| WO BUDGET (Dim_Supplier_ID) - SUPPLIER (ID) |
| WO BUDGET (Dim_Symptom_ID) - SYMPTOM (ID) |
| WO BUDGET (Dim_Vim_Serial_ID) - VIM SERIAL (ID) |
| WO BUDGET (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID) |
| WO BUDGET (Dim_Work_Order_ID) - WORK ORDER (ID) |
| WO BUDGET (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID) |
| WO BUDGET (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WORK TASK ACTUALS COST (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| WORK TASK ACTUALS COST (Dim_Activity_ID) - ACTIVITY (ID) |
| WORK TASK ACTUALS COST (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID) |
| WORK TASK ACTUALS COST (Dim_Cause_ID) - CAUSE (ID) |
| WORK TASK ACTUALS COST (Dim_Class_ID) - CLASS (ID) |
| WORK TASK ACTUALS COST (Dim_Company_ID) - COMPANY (ID) |
| WORK TASK ACTUALS COST (Dim_Customer_ID) - CUSTOMER (ID) |
| WORK TASK ACTUALS COST (Dim_Date_Actual_Compl_ID) - ACTUAL FINISH DATE (ID) |
| WORK TASK ACTUALS COST (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID) |
| WORK TASK ACTUALS COST (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID) |
| WORK TASK ACTUALS COST (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| WORK TASK ACTUALS COST (Dim_Date_Reported_ID) - REPORTING DATE (ID) |
| WORK TASK ACTUALS COST (Dim_Discovery_ID) - DISCOVERY (ID) |
| WORK TASK ACTUALS COST (Dim_Event_ID) - EVENT (ID) |
| WORK TASK ACTUALS COST (Dim_Failing_Component_ID) - FAILING COMPONENT (ID) |
| WORK TASK ACTUALS COST (Dim_Fault_Type_ID) - FAULT TYPE (ID) |
| WORK TASK ACTUALS COST (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID) |
| WORK TASK ACTUALS COST (Dim_Item_Class_ID) - ITEM CLASS (ID) |
| WORK TASK ACTUALS COST (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID) |
| WORK TASK ACTUALS COST (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| WORK TASK ACTUALS COST (Dim_Organization_ID) - ORGANIZATION (ID) |
| WORK TASK ACTUALS COST (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID) |
| WORK TASK ACTUALS COST (Dim_PM_Group_ID) - PM GROUP (ID) |
| WORK TASK ACTUALS COST (Dim_Priority_ID) - PRIORITY (ID) |
| WORK TASK ACTUALS COST (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| WORK TASK ACTUALS COST (Dim_Project_ID) - PROJECT (ID) |
| WORK TASK ACTUALS COST (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID) |
| WORK TASK ACTUALS COST (Dim_Service_Contract_Line_ID) - SERVICE CONTRACT (ID) |
| WORK TASK ACTUALS COST (Dim_Site_ID) - SITE (ID) |
| WORK TASK ACTUALS COST (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID) |
| WORK TASK ACTUALS COST (Dim_Source_Object_ID) - SOURCE OBJECT (ID) |
| WORK TASK ACTUALS COST (Dim_Sub_Project_ID) - SUB PROJECT (ID) |
| WORK TASK ACTUALS COST (Dim_Supplier_ID) - SUPPLIER (ID) |
| WORK TASK ACTUALS COST (Dim_Symptom_ID) - SYMPTOM (ID) |
| WORK TASK ACTUALS COST (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID) |
| WORK TASK ACTUALS COST (Dim_Work_Order_ID) - WORK ORDER (ID) |
| WORK TASK ACTUALS COST (Dim_Work_Stage_ID) - WORK STAGE (ID) |
| WORK TASK ACTUALS COST (Dim_Work_Task_ID) - WORK TASK (ID) |
| WORK TASK ACTUALS COST (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID) |
| WORK TASK ACTUALS COST (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WORK TASK ACTUALS SALES (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| WORK TASK ACTUALS SALES (Dim_Act_Equipment_Object_ID) - REPORTED EQUIPMENT OBJECT (ID) |
| WORK TASK ACTUALS SALES (Dim_Activity_ID) - ACTIVITY (ID) |
| WORK TASK ACTUALS SALES (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID) |
| WORK TASK ACTUALS SALES (Dim_Cause_ID) - CAUSE (ID) |
| WORK TASK ACTUALS SALES (Dim_Class_ID) - CLASS (ID) |
| WORK TASK ACTUALS SALES (Dim_Company_ID) - COMPANY (ID) |
| WORK TASK ACTUALS SALES (Dim_Customer_ID) - CUSTOMER (ID) |
| WORK TASK ACTUALS SALES (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID) |
| WORK TASK ACTUALS SALES (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - REPORTING DATE (ID) |
| WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - SLA LATEST FINISH DATE (ID) |
| WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - SLA LATEST START DATE (ID) |
| WORK TASK ACTUALS SALES (Dim_Discovery_ID) - DISCOVERY (ID) |
| WORK TASK ACTUALS SALES (Dim_Event_ID) - EVENT (ID) |
| WORK TASK ACTUALS SALES (Dim_Failing_Component_ID) - FAILING COMPONENT (ID) |
| WORK TASK ACTUALS SALES (Dim_Fault_Type_ID) - FAULT TYPE (ID) |
| WORK TASK ACTUALS SALES (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID) |
| WORK TASK ACTUALS SALES (Dim_Item_Class_ID) - ITEM CLASS (ID) |
| WORK TASK ACTUALS SALES (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID) |
| WORK TASK ACTUALS SALES (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| WORK TASK ACTUALS SALES (Dim_Organization_ID) - ORGANIZATION (ID) |
| WORK TASK ACTUALS SALES (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID) |
| WORK TASK ACTUALS SALES (Dim_PM_Group_ID) - PM GROUP (ID) |
| WORK TASK ACTUALS SALES (Dim_Priority_ID) - PRIORITY (ID) |
| WORK TASK ACTUALS SALES (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| WORK TASK ACTUALS SALES (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID) |
| WORK TASK ACTUALS SALES (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID) |
| WORK TASK ACTUALS SALES (Dim_Site_ID) - SITE (ID) |
| WORK TASK ACTUALS SALES (Dim_Site_ID) - SOURCE SITE (ID) |
| WORK TASK ACTUALS SALES (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID) |
| WORK TASK ACTUALS SALES (Dim_Source_Object_ID) - SOURCE OBJECT (ID) |
| WORK TASK ACTUALS SALES (Dim_Supplier_ID) - SUPPLIER (ID) |
| WORK TASK ACTUALS SALES (Dim_Symptom_ID) - SYMPTOM (ID) |
| WORK TASK ACTUALS SALES (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID) |
| WORK TASK ACTUALS SALES (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID) |
| WORK TASK ACTUALS SALES (Dim_Work_Order_ID) - WORK ORDER (ID) |
| WORK TASK ACTUALS SALES (Dim_Work_Stage_ID) - WORK STAGE (ID) |
| WORK TASK ACTUALS SALES (Dim_Work_Task_ID) - WORK TASK (ID) |
| WORK TASK ACTUALS SALES (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID) |
| WORK TASK ACTUALS SALES (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WORK TASK PLANNED (Dim_Activity_ID) - ACTIVITY (ID) |
| WORK TASK PLANNED (Dim_Cause_ID) - CAUSE (ID) |
| WORK TASK PLANNED (Dim_Class_ID) - CLASS (ID) |
| WORK TASK PLANNED (Dim_Company_ID) - COMPANY (ID) |
| WORK TASK PLANNED (Dim_Cost_Type_ID) - WO COST TYPE (ID) |
| WORK TASK PLANNED (Dim_Customer_ID) - CUSTOMER (ID) |
| WORK TASK PLANNED (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID) |
| WORK TASK PLANNED (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| WORK TASK PLANNED (Dim_Discovery_ID) - DISCOVERY (ID) |
| WORK TASK PLANNED (Dim_Event_ID) - EVENT (ID) |
| WORK TASK PLANNED (Dim_Fault_Type_ID) - FAULT TYPE (ID) |
| WORK TASK PLANNED (Dim_Linear_Asset_ID) - LINEAR ASSET (ID) |
| WORK TASK PLANNED (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| WORK TASK PLANNED (Dim_Organization_ID) - ORGANIZATION (ID) |
| WORK TASK PLANNED (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID) |
| WORK TASK PLANNED (Dim_Priority_ID) - PRIORITY (ID) |
| WORK TASK PLANNED (Dim_Proj_Program_Id) - PROJECT PROGRAM (ID) |
| WORK TASK PLANNED (Dim_Reporting_Date_ID) - REPORTING DATE (ID) |
| WORK TASK PLANNED (Dim_Site_ID) - SITE (ID) |
| WORK TASK PLANNED (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID) |
| WORK TASK PLANNED (Dim_Sub_Project_ID) - SUB PROJECT (ID) |
| WORK TASK PLANNED (Dim_Supplier_ID) - SUPPLIER (ID) |
| WORK TASK PLANNED (Dim_Symptom_ID) - SYMPTOM (ID) |
| WORK TASK PLANNED (Dim_Vim_Serial_ID) - VIM SERIAL (ID) |
| WORK TASK PLANNED (Dim_Work_Order_ID) - WORK ORDER (ID) |
| WORK TASK PLANNED (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID) |
| WORK TASK PLANNED (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WORK TASK POSTINGS (Dim_Account_ID) - ACCOUNT (ID) |
| WORK TASK POSTINGS (Dim_Activity_ID) - ACTIVITY (ID) |
| WORK TASK POSTINGS (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID) |
| WORK TASK POSTINGS (Dim_Cause_ID) - CAUSE (ID) |
| WORK TASK POSTINGS (Dim_Class_ID) - CLASS (ID) |
| WORK TASK POSTINGS (Dim_Code_B_ID) - CODE B (ID) |
| WORK TASK POSTINGS (Dim_Code_C_ID) - CODE C (ID) |
| WORK TASK POSTINGS (Dim_Code_D_ID) - CODE D (ID) |
| WORK TASK POSTINGS (Dim_Code_E_ID) - CODE E (ID) |
| WORK TASK POSTINGS (Dim_Code_F_ID) - CODE F (ID) |
| WORK TASK POSTINGS (Dim_Code_G_ID) - CODE G (ID) |
| WORK TASK POSTINGS (Dim_Code_H_ID) - CODE H (ID) |
| WORK TASK POSTINGS (Dim_Code_I_ID) - CODE I (ID) |
| WORK TASK POSTINGS (Dim_Code_J_ID) - CODE J (ID) |
| WORK TASK POSTINGS (Dim_Company_ID) - COMPANY (ID) |
| WORK TASK POSTINGS (Dim_Customer_ID) - CUSTOMER (ID) |
| WORK TASK POSTINGS (Dim_Date_Actual_Compl_ID) - ACTUAL FINISH DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_Earliest_Start_ID) - REQUIRED START DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_Latest_Finish_ID) - REQUIRED FINISH DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_SLA_Latest_Finish_ID) - SLA LATEST FINISH DATE (ID) |
| WORK TASK POSTINGS (Dim_Date_SLA_Latest_Start_Id) - SLA LATEST START DATE (ID) |
| WORK TASK POSTINGS (Dim_Discovery_ID) - DISCOVERY (ID) |
| WORK TASK POSTINGS (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID) |
| WORK TASK POSTINGS (Dim_Event_ID) - EVENT (ID) |
| WORK TASK POSTINGS (Dim_Failing_Component_ID) - FAILING COMPONENT (ID) |
| WORK TASK POSTINGS (Dim_Fault_Type_ID) - FAULT TYPE (ID) |
| WORK TASK POSTINGS (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID) |
| WORK TASK POSTINGS (Dim_Item_Class_ID) - ITEM CLASS (ID) |
| WORK TASK POSTINGS (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID) |
| WORK TASK POSTINGS (Dim_Item_Class_Source_ID) - SOURCE CONNECTION (ID) |
| WORK TASK POSTINGS (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID) |
| WORK TASK POSTINGS (Dim_Organisation_Site_ID) - ORGANIZATION SITE (ID) |
| WORK TASK POSTINGS (Dim_Organization_ID) - ORGANIZATION (ID) |
| WORK TASK POSTINGS (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID) |
| WORK TASK POSTINGS (Dim_PM_Group_ID) - PM GROUP (ID) |
| WORK TASK POSTINGS (Dim_Posting_Type_ID) - TASK ACCOUNTING TYPE (ID) |
| WORK TASK POSTINGS (Dim_Priority_ID) - PRIORITY (ID) |
| WORK TASK POSTINGS (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID) |
| WORK TASK POSTINGS (Dim_Project_ID) - PROJECT (ID) |
| WORK TASK POSTINGS (Dim_Rep_Mch_Ref_ID) - REPORTED EQUIPMENT OBJECT (ID) |
| WORK TASK POSTINGS (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID) |
| WORK TASK POSTINGS (Dim_Reporting_Date_Id) - REPORTING DATE (ID) |
| WORK TASK POSTINGS (Dim_Rpd_Company_Period_ID) - REPORTING PERIOD (Company-Date) |
| WORK TASK POSTINGS (Dim_Service_Contract_Line_ID) - SERVICE CONTRACT (ID) |
| WORK TASK POSTINGS (Dim_Site_ID) - SITE (ID) |
| WORK TASK POSTINGS (Dim_Source_Object_ID) - SOURCE OBJECT (ID) |
| WORK TASK POSTINGS (Dim_Source_Site_ID) - SOURCE SITE (ID) |
| WORK TASK POSTINGS (Dim_Sub_Project_ID) - SUB PROJECT (ID) |
| WORK TASK POSTINGS (Dim_Supplier_ID) - SUPPLIER (ID) |
| WORK TASK POSTINGS (Dim_Symptom_ID) - SYMPTOM (ID) |
| WORK TASK POSTINGS (Dim_Time_Type_ID) - TIME TYPE (ID) |
| WORK TASK POSTINGS (Dim_Transaction_Type_ID) - TRANSACTION TYPE (ID) |
| WORK TASK POSTINGS (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID) |
| WORK TASK POSTINGS (Dim_WO_Cost_Type_ID) - WO COST TYPE (ID) |
| WORK TASK POSTINGS (Dim_Work_Order_No_Id) - WORK ORDER (ID) |
| WORK TASK POSTINGS (Dim_Work_Stage_ID) - WORK STAGE (ID) |
| WORK TASK POSTINGS (Dim_Work_Task_Seq_ID) - WORK TASK (ID) |
| WORK TASK POSTINGS (Dim_Work_Type_Cat_ID) - WORK TYPE CATEGORY (ID) |
| WORK TASK POSTINGS (Dim_Work_Type_ID) - WORK TYPE (ID) |
| WORK TASK PLANNED (Dim_Criticality_ID) - CRITICALITY (ID) |
| ASSET HEALTH LEVEL (Level) - COLOR LEVEL (Description) |
| ASSET HEALTH (Asset Health Level) - COLOR LEVEL (Description) |
| ASSET HEALTH (Dim_Company_Id) - COMPANY (ID) |
| ASSET HEALTH (Dim_Site_Id) - SITE (ID) |
| WORK TASK ACTUALS COST (Dim_Site_ID) - ACTUAL OBJECT SITE (ID) |
| WORK TASK ACTUALS SALES (Dim_Site_ID) - ACTUAL OBJECT SITE (ID) |
| WORK TASK POSTINGS (Dim_Actual_Obj_Site_ID) - ACTUAL OBJECT SITE (ID) |
| ASSET HEALTH INDI HST (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID) |
| ASSET HEALTH (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID) |
| ASSET HEALTH HISTORY (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID) |
| ASSET HEALTH LEVEL (Dim_Asset_Type) - ASSET TYPE (ID) |
| ASSET HEALTH (Dim_Asset_Type) - ASSET TYPE (ID) |
| ASSET HEALTH INDICATOR (Dim_Asset_Type) - ASSET TYPE (ID) |
| ASSET HEALTH HISTORY (Dim_Asset_Type) - ASSET TYPE (ID) |
| ASSET HEALTH INDI HST (Dim_Asset_Health_Indicator) - ASSET HEALTH INDICATOR DIMENSION (ID) |
| ASSET HEALTH INDICATOR (ID) - ASSET HEALTH INDICATOR DIMENSION (ID) |
| ASSET HEALTH INDI HST (Dim_Asset_Type) - ASSET TYPE (ID) |
| Locations (ID) - ASSET HEALTH (Dim_Asset_Id) |